//
//  HeroBaseHandle.h
//  LOL_PalmarHelper
//
//  Created by dllo on 15/6/29.
//  Copyright (c) 2015年 hantao. All rights reserved.
//

#import <Foundation/Foundation.h>

#import <sqlite3.h>

#import "HeroModel.h"

#import "VideoModel.h"

#import "VideoListModel.h"


#import "EquipmentModel.h"
#import "ScrollModel.h"
#import "NewsModel.h"
@interface HeroBaseHandle : NSObject


+(instancetype)ShareHeroHeroDate;

-(void)openDB;

-(void)createHeroTable;
-(void)insertHero:(HeroModel *)hero;
-(NSMutableArray *)selectAll;
-(void)dropHerotable;


-(void)createAllHeroTable;
-(void)insertAllHero:(HeroModel *)hero;
-(NSMutableArray *)selectAllHero;
-(void)dropAllHerotable;

// 创建视频导航界面表

-(void)createmyVideoTable;

//  查询视频导航表

-(NSMutableArray *)selectAllmyVideo;

//  插入视频导航

-(void)insertmyVideo:(VideoModel *)video myName:(NSString *)myname;

// 删除视频导航界面表

-(void)dropmyVideoTable;




// ********************
// 创建视频列表界面表

-(void)createmyVideoListTable;

//  查询视频列表的表

-(NSMutableArray *)selectAllmyVideoList;

//  插入视频列表

-(void)insertmyVideoList:(VideoListModel *)video;

// 删除视频列表表
-(void)dropmyVideoListTable:(NSString *)mytag;




-(void)createEquipmentTable;
-(void)insertEquipment:(EquipmentModel *)equipment;
-(NSMutableArray *)selectEquipment;
-(void)dropEquipment;
-(void)insertNews:(NewsModel *)news;
-(void)dropNewsTable;
-(NSMutableArray *)selectNews;
-(void)createNewsTable;




-(void)createScrollTable;
-(void)insertScroll:(ScrollModel *)scroll;
-(NSMutableArray *)selectScroll;
-(void)dropScrollTable;







@end
